<%@page language="java" contentType="text/html; charset=UTF-8" pageEncoding="UTF-8"%>
<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %>
<%@ taglib prefix="sql" uri="http://java.sun.com/jsp/jstl/sql" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>AP_SERVICE_CODE</title>
<LINK href="/monitor/css/basic.css" rel="stylesheet" type="text/css">
<script src="/monitor/jquery-ui-1.10.1.custom/js/jquery-1.9.1.js" type="text/javascript" ></script>
<script src="/monitor/js/basic.js" type="text/javascript" ></script>
</head>
<body>
<c:if test="${!empty param.PARAM_SERVICE_ID}">
   <c:set var="where1" value="AND SERVICE_ID = '${param.PARAM_SERVICE_ID}'" />			
</c:if>
<sql:query var='test' dataSource="basisDataSource">
	SELECT * 
	 FROM AP_SERVICE_CODE
	WHERE 1 = 1
	  AND ROWNUM < 100
	 ${where1}
 </sql:query>	
<h3>AP_SERVICE_CODE</h3>
 <form method="post">
	<table>
		<tr>
			<td>ID</td>
			<td><input name="PARAM_SERVICE_ID" value="${param.PARAM_SERVICE_ID}"></td>
		</tr>
	</table>
	<input type="submit" />
</form>
<br/>
<h3>AP_SERVICE_CODE</h3>
<table border="1">
	<tr>
			<td class="header">SERVICE_ID</td>
			<td class="header">SERVICE_CODE_ID</td>
			<td class="header">CODE_CATEGORY_ID</td>
			<td class="header">SLEEP_INCLUDE_YN</td>
			<td class="header">ALIAS</td>
			<td class="header">FILTER_VALUE</td>
			<td class="header">REG_USER_ID</td>
			<td class="header">REG_DATETIME</td>
			<td class="header">UPD_USER_ID</td>
			<td class="header">UPD_DATETIME</td>
		</tr>
	<tr>
			<td class="header">서비스ID</td>
			<td class="header">서비스코드ID</td>
			<td class="header">코드분류ID</td>
			<td class="header">비활성포함여부</td>
			<td class="header">필터유형</td>
			<td class="header">필터값</td>
			<td class="header">등록사용자ID</td>
			<td class="header">등록일시</td>
			<td class="header">수정사용자ID</td>
			<td class="header">수정일시</td>
		</tr>
	<c:forEach var="row" items="${test.rows}">
	<tr onclick="setLineBGColor(this)">
			<td>${row.SERVICE_ID}</td>
			<td>${row.SERVICE_CODE_ID}</td>
			<td>${row.CODE_CATEGORY_ID}</td>
			<td>${row.SLEEP_INCLUDE_YN}</td>
			<td>${row.ALIAS}</td>
			<td>${row.FILTER_VALUE}</td>
			<td>${row.REG_USER_ID}</td>
			<td>${row.REG_DATETIME}</td>
			<td>${row.UPD_USER_ID}</td>
			<td>${row.UPD_DATETIME}</td>
		</tr>
	</c:forEach>
</table>
</body>
</html> 